package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.bean.LoginBean;

public class linkadd extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		   request. setCharacterEncoding("UTF-8");
		   HttpSession session = request.getSession();
		   String linkname  = request.getParameter("linkname");
		   LoginBean bean =new LoginBean();
		   bean=(LoginBean) session.getAttribute("Loginbean");
		   String username=bean.getUsername();

		   try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   String url ="jdbc:mysql://localhost:3306/graduatedesign" ;
			  Connection conn = null ;
			  Statement stmt = null ;
			  ResultSet rs = null;
			  
			  String sql="insert into link (username,linkname) values (?,?)"; 
			  try {
				conn = DriverManager.getConnection(url, "root", "root") ;
				stmt = conn.createStatement() ;
				PreparedStatement preStmt=conn.prepareStatement(sql);  
	            preStmt.setString(1, username);  
	            preStmt.setString(2, linkname);  
	            int suc = preStmt.executeUpdate(); 
	            if(suc!=0){
	            	System.out.println(sql);
	            	response.sendRedirect("admin/linkmanage.jsp") ;
	            }
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}	 	   	
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

	


}
